package cj.web.marriage.dao;
/*
 *  
 *  
*/
import java.util.List;
import java.util.Map;

import net.paoding.rose.jade.annotation.DAO;
import net.paoding.rose.jade.annotation.SQL;

/**
 * 
 * @author 
 *
 */
@DAO
public interface XQExportDAO{
	
	 @SQL("SELECT a.*,b.phone AS userPhone,c.phone AS objectUserPhone FROM PubYH a LEFT JOIN SCBuyer b on a.userId=b.id LEFT JOIN SCBuyer c ON a.objectUserId=c.id WHERE a.deleteFlag=1 and a.createAt > :1 and a.createAt < :2 ")
	 List<Map> pubYHExcel(String createAt,String endAt);
	 
	 @SQL("SELECT a.*,b.name as pubActivityName,c.phone as userPhone FROM PubActivityOrder a left join PubActivity b on a.pubActivityId=b.id left join SCBuyer c on a.userId =c.id  WHERE a.deleteFlag=1 and a.createAt > :1 and a.createAt < :2 ")
	 List<Map> pubActivityOrderExcel(String createAt,String endAt);
	 
	 @SQL("SELECT a.*,b.phone AS userPhone,c.phone AS objectUserPhone FROM CmpYH a LEFT JOIN SCBuyer b on a.userId=b.id LEFT JOIN SCBuyer c ON a.objectUserId=c.id WHERE a.deleteFlag=1 and a.createAt > :1 and a.createAt < :2 ")
	 List<Map> cmpYHExcel(String createAt,String endAt);
	 
	 @SQL("SELECT a.*,b.name as cmpActivityName,c.phone as userPhone FROM CmpActivityOrder a left join CmpActivity b on a.cmpActivityId=b.id left join SCBuyer c on a.userId =c.id  WHERE a.deleteFlag=1 and a.createAt > :1 and a.createAt < :2 ")
	 List<Map> cmpActivityOrderExcel(String createAt,String endAt);
}